oracle 多个字段查询其中一个字段求和答:数据 create table test(fbm int,fxm varchar(10),ftem varchar(10),fje int);insert into test values (1,'张三','吃饭',20);insert into test values (1,'张三','睡觉',21);insert into test values (1,'张三','起床',22);insert into test values (4,'落笔','跑步',23);insert...
Oracle表之间字段值的插入问题答:insert into tb (a,b,c,d,e,f,h,i,j,k)select tb1.a,tb1.b,tb1.c,tb2.d,tb3.e,tb3.f,tb4.h,tb4.i,tb4.j,tb4.k from tb1,tb2,tb3,tb4 where tb2.c=tb1.c